Automation multiplies whatever process you point it at. Fix the process manually first, then automate the version that works.
Not every repetitive task should be automated. A four-way decision framework for working out what to do with each one.